CREATE database if NOT EXISTS `els_admin` default character set utf8mb4 collate utf8mb4_general_ci;
use `els_admin`;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for pay_config
-- ----------------------------
DROP TABLE IF EXISTS `pay_config`;
CREATE TABLE `pay_config` (
  `pay_config_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '住建，appId',
  `type` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '支付类型',
  `config_json` text COLLATE utf8mb4_bin COMMENT '配置信息',
  `multiple` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否多实例',
  `status` int DEFAULT '0' COMMENT '状态',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`pay_config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='支付配置';

-- ----------------------------
-- Records of pay_config
-- ----------------------------
BEGIN;
INSERT INTO `pay_config` (`pay_config_id`, `type`, `config_json`, `multiple`, `status`, `create_at`, `update_at`) VALUES ('微信appid', 'wxPay', '{\n          \"appId\": \"微信appid\",\n          \"mchId\": \"商户号\",\n          \"slAppId\": \"服务商AppId\",\n          \"slMchId\": \"服务商商户号\",\n          \"apiKey\": \"api秘钥32位\",\n          \"apiKey3\": \"apiV3秘钥32位\",\n          \"domain\": \"回调地址\",\n          \"certP12Path\": \"p12证书路径\",\n          \"keyPath\": \"apiclient_key.pem路径\",\n          \"certPath\": \"apiclient_cert.pem路径\",\n          \"platformCertPath\": \"平台证书路径\"\n        }', 1, 0, '2024-02-08 07:25:19', '2024-02-18 18:17:45');
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `config_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '配置ID',
  `config_key` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT ' 配置键',
  `config_name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '配置名称',
  `config_value` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '配置值',
  `config_type` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '配置类型',
  `remark` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `valid_flag` varchar(3) COLLATE utf8mb4_bin NOT NULL DEFAULT '1' COMMENT '状态 0无效 1有效',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户ID',
  `create_by` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '创建人',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '修改人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='配置管理';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`config_id`, `config_key`, `config_name`, `config_value`, `config_type`, `remark`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809528621455388673', 'tx', 'tx', 'b4wtgZppOK', 'tx', NULL, '1', '0', '1', '2024-07-06 18:03:37', '1', '2024-07-06 18:03:37');
INSERT INTO `sys_config` (`config_id`, `config_key`, `config_name`, `config_value`, `config_type`, `remark`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1810335034641514498', 'tx', 'tx', 'v0b8KucczK', 'tx', NULL, '1', '0', '1', '2024-07-08 23:28:01', '1', '2024-07-08 23:28:01');
INSERT INTO `sys_config` (`config_id`, `config_key`, `config_name`, `config_value`, `config_type`, `remark`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1810335850263932930', 'tx', 'tx', 'q1C5GnIegY', 'tx', NULL, '1', '0', '1', '2024-07-08 23:31:16', '1', '2024-07-08 23:31:16');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '部门ID',
  `parent_id` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '父级部门ID',
  `dept_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门名称',
  `org_code` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门代码',
  `org_category` int DEFAULT NULL COMMENT '部门类型',
  `mobile` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门电话',
  `address` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门地址',
  `order_no` int NOT NULL DEFAULT '0' COMMENT '排序',
  `status` int DEFAULT '0' COMMENT '状态',
  `dept_desc` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1', '0', '财务部', '000000', 1, '12345678901', '中国', 0, 0, '顶级部门', '2020-06-05 11:06:00', 'admin', NULL, 'admin', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1835623282062229506', '0', '测试部门', 'A001', 0, '1321311212', 'GUIZHOU', 1, 0, '测试1', '2024-09-16 18:14:00', NULL, '2024-09-16 18:14:00', NULL, '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1835623422642716673', '1835623282062229506', '测试 1', 'A011', 1, NULL, NULL, 0, 0, NULL, '2024-09-16 18:15:03', NULL, '2024-09-16 18:15:03', NULL, '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1843347610153373698', '1835623282062229506', '总经理', 'A001', 1, '23221', 'GUIZHOU', 0, 0, NULL, '2024-10-08 01:48:13', NULL, '2024-10-08 01:48:13', NULL, '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1843347717959569410', '1835623282062229506', '贵阳分公司', 'A011', 1, '23221', 'GUIZHOU', 0, 0, NULL, '2024-10-08 01:48:38', NULL, '2024-10-08 01:48:38', NULL, '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('2', '0', '人力资源部', '000000', 1, '12345678901', '中国', 0, 0, 'hr', '2020-06-05 11:06:00', 'admin', '2020-06-05 11:06:00', 'admin', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('2000', '2', '会计部门', '000000', 1, '12345678901', '中国', 0, 0, 'hr', '2020-06-05 11:06:06', 'admin', '2020-06-05 11:06:06', 'admin', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `order_no`, `status`, `dept_desc`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('2001', '2', '出纳部门', '000000', 1, '12345678901', '中国', 0, 0, 'hr', '2020-06-05 11:06:06', 'admin', '2020-06-05 11:06:06', 'admin', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_dept_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_dept_role`;
CREATE TABLE `sys_dept_dept_role` (
  `dept_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '部门ID',
  `dept_role_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '部门角色ID',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`dept_id`,`dept_role_id`,`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='部门角色部门关系';

-- ----------------------------
-- Records of sys_dept_dept_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_menu`;
CREATE TABLE `sys_dept_menu` (
  `dept_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '部门ID',
  `menu_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单ID',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`dept_id`,`menu_id`,`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色菜单';

-- ----------------------------
-- Records of sys_dept_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('1802714504916643842', '1801290765519847426', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('1802714504916643842', '3000', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('1802714504916643842', '3001', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('2', '1759874756913139713', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('2', '1759875183046037505', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('2', '1759875298217431041', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('2', '1759875383483437058', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('2', '2001', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('2', '2003', '0');
INSERT INTO `sys_dept_menu` (`dept_id`, `menu_id`, `tenant_id`) VALUES ('2', '2005', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `dict_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '字典ID',
  `dict_code` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '字典类型',
  `dict_name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '字典名称',
  `dict_type` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '标准类型',
  `website` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '参考网站',
  `remark` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `valid_flag` varchar(3) COLLATE utf8mb4_bin NOT NULL DEFAULT '1' COMMENT '状态 0无效 1有效',
  `release_date` datetime DEFAULT NULL COMMENT '发布日期',
  `Implementation_date` datetime DEFAULT NULL COMMENT '实施日期',
  `revocatory_date` datetime DEFAULT NULL COMMENT '废止日期',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户ID',
  `create_by` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '创建人',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '修改人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE KEY `tenant_dict_code` (`tenant_id`,`dict_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户管理';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`dict_id`, `dict_code`, `dict_name`, `dict_type`, `website`, `remark`, `valid_flag`, `release_date`, `Implementation_date`, `revocatory_date`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1802700771033100290', 'VALID_FLAG', '有效标志-状态', NULL, NULL, '0 无效 1 有效', '1', NULL, NULL, NULL, '0', '1', '2024-07-05 01:28:35', '1', '2024-07-05 01:28:41');
INSERT INTO `sys_dict` (`dict_id`, `dict_code`, `dict_name`, `dict_type`, `website`, `remark`, `valid_flag`, `release_date`, `Implementation_date`, `revocatory_date`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516243970', 'STD_CATEGORY', '标准信息类别', NULL, 'https://std.samr.gov.cn/', '标准信息类别', '1', NULL, NULL, NULL, '0', '0', '2024-07-27 09:08:20', '1', '2024-07-27 09:08:24');
INSERT INTO `sys_dict` (`dict_id`, `dict_code`, `dict_name`, `dict_type`, `website`, `remark`, `valid_flag`, `release_date`, `Implementation_date`, `revocatory_date`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516243980', 'CONFIG_TYPE', '配置类型', NULL, NULL, '配置值类型', '1', NULL, NULL, NULL, '0', '1', '2024-07-06 17:37:49', '1', '2024-07-06 17:37:54');
INSERT INTO `sys_dict` (`dict_id`, `dict_code`, `dict_name`, `dict_type`, `website`, `remark`, `valid_flag`, `release_date`, `Implementation_date`, `revocatory_date`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516243989', 'HBBA_CATEGORY', '行业标准', NULL, 'https://hbba.sacinfo.org.cn/', '行业标准', '1', NULL, NULL, NULL, '0', '1', '2024-07-06 17:37:49', '1', '2024-07-06 17:37:54');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item` (
  `dict_item_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '字典项ID',
  `dict_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '字典ID',
  `label` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '字典项名称',
  `value` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '字典项值',
  `order_no` int NOT NULL DEFAULT '0' COMMENT '排序',
  `valid_flag` varchar(3) COLLATE utf8mb4_bin NOT NULL DEFAULT '1' COMMENT '状态 0无效 1有效',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户ID',
  `create_by` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '创建人',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '修改人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`dict_item_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1802700771033100290', '1802700771033100290', '0', '无效', 1, '1', '0', '1', '2024-07-06 14:40:42', '1', '2024-07-06 14:40:49');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1802700771033110290', '1802700771033100290', '1', '有效', 0, '1', '0', '1', '2024-07-06 14:40:42', '1', '2024-07-06 14:40:49');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213979', '1809301861516243979', 'string', '字符串', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:53');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213980', '1809301861516243979', 'number', '数字', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:53');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213981', '1809301861516243979', 'boolean', '布尔', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:53');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213982', '1809301861516243979', 'array', '数组', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:53');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213983', '1809301861516243979', 'map', '集合', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:53');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213984', '1809301861516243970', '0', '国际标准', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213985', '1809301861516243970', '10', '国家标准', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213986', '1809301861516243970', '11', '国外标准', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213987', '1809301861516243970', '100', '行业标准', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213988', '1809301861516243970', '1000', '地方标准', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213989', '1809301861516243970', '10000', '团体标准', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213990', '1809301861516243970', '100000', '企业标准', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213991', '1809301861516243989', 'AQ', '安全生产', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213992', '1809301861516243990', 'BB', '包装', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213993', '1809301861516243990', 'CB', '船舶', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213994', '1809301861516243990', 'CH', '测绘', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213995', '1809301861516243990', 'CJ', '城镇建设', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213996', '1809301861516243990', 'CY', '新闻出版', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213997', '1809301861516243990', 'DA', '档案', 0, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213998', '1809301861516243990', 'DB', '地震', 1, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516213999', '1809301861516243990', 'DL', '电力', 2, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214000', '1809301861516243990', 'DY', '电影', 3, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214001', '1809301861516243990', 'DZ', '地质矿产', 4, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214002', '1809301861516243990', 'EJ', '核工业', 5, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214003', '1809301861516243990', 'FZ', '纺织', 6, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214004', '1809301861516243990', 'GA', '公共安全', 7, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214005', '1809301861516243990', 'GC', '国家物资储备', 8, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214006', '1809301861516243990', 'GF', '国防工业', 10, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214007', '1809301861516243990', 'GH', '供销合作', 11, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214008', '1809301861516243990', 'GM', '国密', 12, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214009', '1809301861516243990', 'GY', '广播电视和网络视听', 13, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214010', '1809301861516243990', 'HB', '航空', 14, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214011', '1809301861516243990', 'HG', '化工', 15, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214012', '1809301861516243990', 'HJ', '环境保护', 17, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214013', '1809301861516243990', 'HS', '海关', 18, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214014', '1809301861516243990', 'HY', '海洋', 19, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214015', '1809301861516243990', 'JB', '机械', 20, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214016', '1809301861516243990', 'JC', '建材', 21, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214017', '1809301861516243990', 'JG', '建筑工程', 22, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214018', '1809301861516243990', 'JR', '金融', 23, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214019', '1809301861516243990', 'JS', '机关事务', 24, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214020', '1809301861516243990', 'JT', '交通', 25, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214021', '1809301861516243990', 'JY', '教育', 26, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214022', '1809301861516243990', 'KA', '矿山安全', 27, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214023', '1809301861516243990', 'LB', '旅游', 28, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214024', '1809301861516243990', 'LD', '劳动和劳动安全', 29, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214025', '1809301861516243990', 'LS', '粮食', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214026', '1809301861516243990', 'LG', '林业', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214027', '1809301861516243990', 'MH', '民用航空', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214028', '1809301861516243990', 'MR', '市场监管', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214029', '1809301861516243990', 'MT', '煤炭', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214030', '1809301861516243990', 'MZ', '民政', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214031', '1809301861516243990', 'NB', '能源', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214032', '1809301861516243990', 'NY', '农业', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214033', '1809301861516243990', 'QB', '轻工', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214034', '1809301861516243990', 'QC', '汽车', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214035', '1809301861516243990', 'QX', '气象', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214036', '1809301861516243990', 'RB', '认证认可', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214037', '1809301861516243990', 'SB', '国内贸易', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214038', '1809301861516243990', 'SC', '水产', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214039', '1809301861516243990', 'SFSF', '司法', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214040', '1809301861516243990', 'SH', '石油化工', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214041', '1809301861516243990', 'SJ', '电子', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214042', '1809301861516243990', 'SL', '水利', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214043', '1809301861516243990', 'SN', '出入境检验检疫', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214044', '1809301861516243990', 'SW', '税务', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214045', '1809301861516243990', 'SY', '石油天然气', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214046', '1809301861516243990', 'TB', '铁路', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214047', '1809301861516243990', 'TD', '土地管理', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214048', '1809301861516243990', 'TY', '体育', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214049', '1809301861516243990', 'WB', '物资管理', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214050', '1809301861516243990', 'WH', '文化', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214051', '1809301861516243990', 'WJ', '兵工民品', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214052', '1809301861516243990', 'WM', '外经贸', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214053', '1809301861516243990', 'WS', '卫生', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214054', '1809301861516243990', 'WW', '文物保护', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214055', '1809301861516243990', 'XB', '稀土', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214056', '1809301861516243990', 'XF', '消防救援', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214057', '1809301861516243990', 'YB', '黑色冶金', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214058', '1809301861516243990', 'YC', '烟草', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214059', '1809301861516243990', 'YD', '通信', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214060', '1809301861516243990', 'YJ', '减灾救灾与综合性应急管理', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214061', '1809301861516243990', 'YS', '有色金属', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214062', '1809301861516243990', 'YY', '医药', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214063', '1809301861516243990', 'YZ', '邮政', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
INSERT INTO `sys_dict_item` (`dict_item_id`, `dict_id`, `label`, `value`, `order_no`, `valid_flag`, `tenant_id`, `create_by`, `create_at`, `update_by`, `update_at`) VALUES ('1809301861516214064', '1809301861516243990', 'ZY', '中医药', 30, '1', '0', '1', '2024-07-06 17:39:50', '1', '2024-07-06 17:39:50');
COMMIT;

-- ----------------------------
-- Table structure for sys_federated_identity
-- ----------------------------
DROP TABLE IF EXISTS `sys_federated_identity`;
CREATE TABLE `sys_federated_identity` (
  `id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '第三方应用 id',
  `user_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '用户id',
  `identifier` varchar(128) COLLATE utf8mb4_bin NOT NULL COMMENT '第三方应用的唯一标识',
  `identity_type` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '第三方应用名称 (微信, 微博,qq.gitee,github等)',
  `attributes` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '第三方登录的属性集合',
  `authorized_client_registration_id` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '授权客户端注册Id',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户id',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='联合登录信息表 第三方登录';

-- ----------------------------
-- Records of sys_federated_identity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单id',
  `parent_id` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '父级菜单ID',
  `menu_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '菜单名称',
  `permission` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限',
  `route_path` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '路由地址',
  `icon` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图标',
  `component` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组件',
  `is_show` tinyint(1) DEFAULT '1' COMMENT '是否显示',
  `keep_alive` tinyint(1) DEFAULT '1' COMMENT '是否缓存',
  `is_ext` tinyint(1) DEFAULT '0' COMMENT '是否外链',
  `type` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单类型，0目录，1菜单，2按钮',
  `order_no` int NOT NULL DEFAULT '0' COMMENT '排序',
  `status` int DEFAULT '0' COMMENT '状态',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  `create_by` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `delete_flag` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1000', '0', '仪表板', 'userinfo', '/dashboard', 'ion:layers-outline', 'LAYOUT', 1, 0, 0, '0', 1, 0, '2023-11-01 02:24:31', '2023-11-01 02:24:34', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1001', '1000', '分析', NULL, '/dashboard/analysis', 'bx:bx-home', '/dashboard/analysis/index', 1, 0, 0, '1', 1, 0, '2023-11-01 02:38:42', '2023-11-01 02:38:44', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1002', '1000', '工作台', NULL, '/dashboard/workbench', 'bx:bx-home', '/dashboard/workbench/index', 1, 0, 0, '1', 2, 0, '2023-11-01 02:45:46', '2023-11-01 02:40:10', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1753838064745844737', '2003', '修改菜单', 'menu:edit', NULL, NULL, NULL, 1, 1, 0, '2', 2, 0, '2024-02-04 01:49:16', '2024-02-04 01:49:16', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759756582691561473', '2001', '新增用户', 'user:create', '', '', '', 1, 1, 0, '2', 1, 0, '2024-02-20 09:47:19', '2024-02-20 09:48:37', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759796776249602050', '2001', '更新用户', 'user:update', '', '', '', 1, 1, 0, '2', 2, 0, '2024-02-20 12:27:02', '2024-02-20 12:27:02', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759803126056759298', '2001', '删除用户', 'user:delete', '', '', '', 1, 1, 0, '2', 3, 0, '2024-02-20 12:52:15', '2024-02-20 12:52:15', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759805834515984386', '2002', '添加角色', 'role:add', '', '', '', 1, 1, 0, '2', 1, 0, '2024-02-20 13:03:01', '2024-02-20 13:03:01', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759873891401732097', '2002', '更新角色', 'role:edit', '', '', '', 1, 1, 0, '2', 2, 0, '2024-02-20 17:33:27', '2024-02-20 17:33:27', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759874353278488578', '2002', '删除角色', 'role:delete', '', '', '', 1, 1, 0, '2', 3, 0, '2024-02-20 17:35:17', '2024-02-20 17:35:17', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759874756913139713', '2003', '删除菜单', 'menu:delete', '', '', '', 1, 1, 0, '2', 3, 0, '2024-02-20 17:36:54', '2024-02-20 17:36:54', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759875183046037505', '2004', '添加部门', 'dept:add', '', '', '', 1, 1, 0, '2', 1, 0, '2024-02-20 17:38:35', '2024-02-20 17:38:35', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759875298217431041', '2004', '更新部门', 'dept:update', '', '', '', 1, 1, 0, '2', 2, 0, '2024-02-20 17:39:03', '2024-02-20 17:39:03', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1759875383483437058', '2004', '删除部门', 'dept:delete', '', '', '', 1, 1, 0, '2', 3, 0, '2024-02-20 17:39:23', '2024-02-20 17:39:23', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('1801290765519847426', '0', '类别管理', '', '/mall', 'ant-design:account-book-outlined', 'LAYOUT', 0, 1, 0, '0', 1, 1, '2024-06-14 00:29:20', NULL, '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('2000', '0', '系统管理', NULL, '/system', 'bx:bx-home', 'LAYOUT', 1, 0, 0, '0', 2, 0, '2023-11-01 02:45:44', '2023-11-01 02:45:48', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('2001', '2000', '账号管理', 'user:list', '/system/user', 'bx:bx-home', '/system/user/index', 1, 0, 0, '1', 1, 0, '2023-11-01 02:46:23', '2023-11-01 02:46:21', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('2002', '2000', '角色管理', 'role:list', '/system/role', 'bx:bx-home', '/system/role/index', 1, 0, 0, '1', 1, 0, '2023-11-01 02:50:35', '2023-11-01 02:50:37', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('2003', '2000', '菜单管理', 'menu:list', '/system/menu', 'bx:bx-home', '/system/menu/index', 1, 0, 0, '1', 1, 0, '2023-11-01 02:51:25', '2023-11-01 02:51:23', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('20031', '2003', '添加菜单', 'menu:add', NULL, NULL, NULL, 1, 0, 0, '2', 1, 0, '2024-02-04 01:37:48', '2024-02-04 01:37:50', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('2004', '2000', '部门管理', 'dept:list', '/system/dept', 'bx:bx-home', '/system/dept/index', 1, 0, 0, '1', 1, 0, '2023-11-01 02:57:44', '2023-11-01 02:57:47', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('2005', '2000', '权限管理', NULL, '/system/permission', 'bx:bx-home', '/system/permission/index', 1, 0, 0, '1', 1, 0, '2024-06-17 00:14:17', '2024-06-17 00:14:18', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('3000', '0', '支付管理', NULL, '/pay', 'bx:bx-home', 'LAYOUT', 1, 0, 0, '0', 1, 0, '2024-02-04 02:49:59', '2024-02-04 02:50:01', '0', NULL, NULL, 0);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `permission`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `order_no`, `status`, `create_at`, `update_at`, `tenant_id`, `create_by`, `update_by`, `delete_flag`) VALUES ('3001', '3000', '支付配置', 'pay:config', '/pay/config', 'bx:bx-home', '/pay/config/index', 1, 0, 0, '1', 1, 0, '2024-02-04 02:56:03', NULL, '0', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_permission`;
CREATE TABLE `sys_menu_permission` (
  `menu_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单 id',
  `permission_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '权限id',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`menu_id`,`permission_id`,`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_menu_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802384339682533377', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802700353909567489', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802700771033100290', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802705076406464514', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802706916997083137', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802713766639448065', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802714379326599169', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802722993034522625', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802740972954595329', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802743812469043201', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '1802747343643291649', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '20007', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '2001', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '2002', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '2003', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2001', '2006', '0');
INSERT INTO `sys_menu_permission` (`menu_id`, `permission_id`, `tenant_id`) VALUES ('2005', '2005', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `permission_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '权限ID',
  `name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限名称',
  `code` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限编码',
  `type` int DEFAULT NULL COMMENT '权限类型',
  `uri` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'uri',
  `pg_id` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限组id',
  `order_no` int NOT NULL DEFAULT '0' COMMENT '排序',
  `description` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `status` int DEFAULT '0' COMMENT '状态',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='权限管理';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission` (`permission_id`, `name`, `code`, `type`, `uri`, `pg_id`, `order_no`, `description`, `status`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('12', '用户列表', 'USER_LIST', 1, '/user/list', '1', 22, '用户列表', 0, NULL, NULL, NULL, NULL, '0', '0');
INSERT INTO `sys_permission` (`permission_id`, `name`, `code`, `type`, `uri`, `pg_id`, `order_no`, `description`, `status`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1849477641288028162', '创建用户', NULL, 1, '/user/add', NULL, 2, NULL, 0, '2024-10-24 23:46:46', NULL, '2024-10-24 23:46:46', NULL, '0', '0');
INSERT INTO `sys_permission` (`permission_id`, `name`, `code`, `type`, `uri`, `pg_id`, `order_no`, `description`, `status`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1849479605946159106', '创建用户', NULL, 1, '/user/add', '1', 2, NULL, 0, '2024-10-24 23:54:34', NULL, '2024-10-24 23:54:34', NULL, '0', '0');
INSERT INTO `sys_permission` (`permission_id`, `name`, `code`, `type`, `uri`, `pg_id`, `order_no`, `description`, `status`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1849480133220503554', '更新用户信息', 'USER_EDIT1', 1, '/user/edit', '1', 0, NULL, 0, '2024-10-24 23:56:40', NULL, NULL, NULL, '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_permission_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission_group`;
CREATE TABLE `sys_permission_group` (
  `pg_id` varchar(256) COLLATE utf8mb4_bin NOT NULL COMMENT '权限组id',
  `name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限名称',
  `description` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `order_no` int NOT NULL DEFAULT '0' COMMENT '排序',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`pg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='权限组管理';

-- ----------------------------
-- Records of sys_permission_group
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission_group` (`pg_id`, `name`, `description`, `order_no`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1', '用户管理2', '用户管理', 1, '2024-10-14 02:57:09', NULL, NULL, NULL, '0', '0');
INSERT INTO `sys_permission_group` (`pg_id`, `name`, `description`, `order_no`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1845558374595342338', 'admin', 'wqw', 0, '2024-10-14 04:13:00', NULL, NULL, NULL, '1', '0');
INSERT INTO `sys_permission_group` (`pg_id`, `name`, `description`, `order_no`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1845566350055997442', 'qwq', 'qw', 0, '2024-10-14 04:44:41', NULL, NULL, NULL, '1', '0');
INSERT INTO `sys_permission_group` (`pg_id`, `name`, `description`, `order_no`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1849486807742283777', '创建用户', 'wewe', 0, '2024-10-25 00:23:11', NULL, '2024-10-25 00:23:11', NULL, '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '角色ID',
  `role_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色名称',
  `role_code` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色编码',
  `role_desc` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色描述',
  `order_no` int NOT NULL DEFAULT '0' COMMENT '排序',
  `status` int DEFAULT '0' COMMENT '状态',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色管理';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `order_no`, `status`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1836065462207672321', '测试', 'TEST1', 'cdxs', 0, 0, '2024-09-17 23:31:33', NULL, NULL, NULL, '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '角色ID',
  `menu_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单ID',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色菜单';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1000', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1001', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1002', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1753838064745844737', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759756582691561473', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759796776249602050', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759803126056759298', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759805834515984386', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759873891401732097', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759874353278488578', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759874756913139713', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759875183046037505', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759875298217431041', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '1759875383483437058', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '2000', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '2001', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '2002', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '2003', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '20031', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '2004', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '2005', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '3000', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1', '3001', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户id',
  `tenant_name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户名称',
  `tenant_code` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户编码',
  `tenant_domain` varchar(256) COLLATE utf8mb4_bin NOT NULL COMMENT '租户域名',
  `tenant_contact` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户联系人',
  `tenant_contact_phone` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户联系电话',
  `tenant_contact_email` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户联系邮箱',
  `tenant_logo` varchar(256) COLLATE utf8mb4_bin NOT NULL COMMENT '租户logo',
  `tenant_type` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户类型',
  `memo` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `valid_flag` varchar(3) COLLATE utf8mb4_bin NOT NULL DEFAULT '1' COMMENT '状态 0无效 1有效',
  `create_by` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  PRIMARY KEY (`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='租户管理';

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant` (`tenant_id`, `tenant_name`, `tenant_code`, `tenant_domain`, `tenant_contact`, `tenant_contact_phone`, `tenant_contact_email`, `tenant_logo`, `tenant_type`, `memo`, `valid_flag`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`) VALUES ('1817622246370426882', 'asas', 'sa', 'assa', 'sa', 'as', 'as', 'sa', 'as', 'asas', '0', NULL, '2024-07-29 02:04:48', NULL, NULL, '0');
INSERT INTO `sys_tenant` (`tenant_id`, `tenant_name`, `tenant_code`, `tenant_domain`, `tenant_contact`, `tenant_contact_phone`, `tenant_contact_email`, `tenant_logo`, `tenant_type`, `memo`, `valid_flag`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`) VALUES ('1817648592681267201', 'ass', 'as', 'asas', 'as', '14345678901', 'as', 'as', 'sa', NULL, '1', NULL, '2024-07-29 03:49:29', NULL, NULL, '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_tenant_applications
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant_applications`;
CREATE TABLE `sys_tenant_applications` (
  `application_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '申请id',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '租户id',
  `identifying_code` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '识别码',
  `application_date` date NOT NULL COMMENT '申请日期',
  `company_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '公司名称',
  `contact_person` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '联系人姓名',
  `contact_email` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '联系人邮箱',
  `contact_phone` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '联系电话',
  `industry` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '行业',
  `website` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '公司网站',
  `service_interests` text COLLATE utf8mb4_bin COMMENT '感兴趣的服务',
  `user_estimate` int DEFAULT NULL COMMENT '用户估计数量',
  `data_storage_requirement` int DEFAULT NULL COMMENT '数据存储需求,单位GB',
  `sla_requirements` text COLLATE utf8mb4_bin COMMENT '服务级别协议要求',
  `security_requirements` text COLLATE utf8mb4_bin COMMENT '安全合规性要求',
  `special_notes` text COLLATE utf8mb4_bin COMMENT '特殊需求或说明',
  `status` varchar(32) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '申请状态 0 Pending待定, 1 Approved批准 -1 Rejected拒绝',
  `valid_flag` varchar(3) COLLATE utf8mb4_bin NOT NULL DEFAULT '1' COMMENT '状态 0无效 1有效',
  `create_by` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  PRIMARY KEY (`application_id`),
  UNIQUE KEY `contact_email` (`contact_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='租户申请表';

-- ----------------------------
-- Records of sys_tenant_applications
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '用户ID',
  `username` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `nickname` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '昵称',
  `sex` int DEFAULT NULL COMMENT '性别',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `password` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
  `avatar` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
  `email` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(11) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号',
  `status` int DEFAULT '0' COMMENT '状态',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户管理';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `username`, `nickname`, `sex`, `birthday`, `password`, `avatar`, `email`, `phone`, `status`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1123', 'admin', '管理员121', 1, '2024-09-19 00:00:00', '{bcrypt}$2a$10$0INtS9wxpbmvMrYSWNWqhOB90UppvT3YstBz5eZLzzFjfFlJcSEY2', NULL, '267@qq.comq', '13212341235', 0, NULL, NULL, NULL, NULL, '0', '0');
INSERT INTO `sys_user` (`user_id`, `username`, `nickname`, `sex`, `birthday`, `password`, `avatar`, `email`, `phone`, `status`, `create_at`, `create_by`, `update_at`, `update_by`, `delete_flag`, `tenant_id`) VALUES ('1843342291209658369', 'root232', '管理', 0, '2024-10-04 00:00:00', '{bcrypt}$2a$10$YxSsAtMPSBlDcoMt0JoQwubQporNpiVrzVF6iQ5WovoP34gMXCXa2', NULL, '267@qq.comsf', '13212341238', 0, '2024-10-08 01:27:05', NULL, NULL, NULL, '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_dept`;
CREATE TABLE `sys_user_dept` (
  `user_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '用户ID',
  `dept_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '部门ID',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`user_id`,`dept_id`,`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户部门关系';

-- ----------------------------
-- Records of sys_user_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_dept` (`user_id`, `dept_id`, `tenant_id`) VALUES ('1123', '1835623422642716673', '0');
INSERT INTO `sys_user_dept` (`user_id`, `dept_id`, `tenant_id`) VALUES ('1123', '2', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_menu`;
CREATE TABLE `sys_user_menu` (
  `user_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '用户id',
  `menu_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单ID',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`user_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户权限表';

-- ----------------------------
-- Records of sys_user_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '用户ID',
  `role_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '角色ID',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '租户id',
  PRIMARY KEY (`user_id`,`role_id`,`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色用户';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tenant_charges
-- ----------------------------
DROP TABLE IF EXISTS `tenant_charges`;
CREATE TABLE `tenant_charges` (
  `tenant_charges_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户费用id',
  `tenant_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户id ',
  `charge_type` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '费用类型 0 Usage使用 1 Subscription 订阅 2 Penalty罚款',
  `charge_amount` decimal(10,2) NOT NULL COMMENT '费用金额',
  `charge_time` datetime NOT NULL COMMENT '费用发生时间',
  `billing_period` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '计费周期 -1 permanent 0 Yearly 年度 1 Quarterly 季度 2 Monthly 月度',
  `payment_method` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '支付方式 1 BankTransfer银行转账',
  `payment_status` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '支付状态 0 Pending待支付 1 Paid已支付 2 Overdue逾期',
  `invoice_number` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '发票编号',
  `memo` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `create_by` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `update_at` datetime DEFAULT NULL COMMENT '修改时间',
  `delete_flag` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除时间(软删除)0 未删除 1 已删除',
  PRIMARY KEY (`tenant_charges_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='租户费用表';

-- ----------------------------
-- Records of tenant_charges
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
